using FarPoint.Win.Spread;
using FarPoint.Win.Spread.CellType;
using System;
using System.Drawing;

namespace Spread.Sparkline.Features
{
    public partial class YearSparkline : Spread.Common.Features.Sample.BaseSampleControl
    {
        private Random _rand;
        public YearSparkline()
        {
            InitializeComponent();
            Name = "Year";
            _rand = new Random();
            InitNormalSheet(_fpSpread.Sheets[0]);
            InitColorRangeSheet(_fpSpread.Sheets[1]);
        }

        #region Private Methods
        private void InitColorRangeSheet(SheetView sheetView)
        {
            var worksheet = sheetView.AsWorksheet();
            worksheet.Name = "ColorRange";
            worksheet.Cells["A1"].Text = "Date";
            worksheet.Cells["B1"].Text = "Value";
            worksheet.Cells["C1"].Text = "Color";
            worksheet.Cells["D1"].Text = "Diagram";
            worksheet.RowCount = 367;

            worksheet.Cells["A2:A367"].CellType = new DateTimeCellType()
            {
                DateTimeFormat = DateTimeFormat.UserDefined,
                UserDefinedFormat = "yyyy-MM-dd"
            };

            worksheet.Columns["A"].ColumnWidth = 80;
            worksheet.Columns["B"].ColumnWidth = 60;
            worksheet.Columns["C"].ColumnWidth = 80;
            worksheet.Columns["D"].ColumnWidth = 600;

            worksheet.Cells["D3:M6"].Merge();

            var colorList = new string[] { "#82bc00", "#9fc94c", "#00C2D6", "#d2e4a7", "#e9f2d2", "#ffedd3", "#ffdba8", "#ffc97d", "#feb850", "#f7a711", "#00c2d6" };

            DateTime date = new DateTime(2020, 1, 1);
            for (var row = 1; row < worksheet.RowCount; row++)
            {
                worksheet.Cells[$"A{row}"].Value = date.AddDays(row - 1);
                worksheet.Cells[$"B{row}"].Value = Math.Round(_rand.NextDouble() * 100);
                worksheet.Cells[$"C{row}"].Value = colorList[_rand.Next(0, colorList.Length)];
            }

            worksheet.Cells["A1:C367"].HorizontalAlignment = GrapeCity.Spreadsheet.HorizontalAlignment.Center;
            sheetView.Cells["A1:D1"].BackColor = ColorTranslator.FromHtml("#999999");
            sheetView.Cells["A1:D1"].ForeColor = ColorTranslator.FromHtml("#FFFFFF");

            worksheet.Cells["D3"].Formula2 = $"YearSparkline(2020, A2:B{worksheet.RowCount}, C2:C366)";
        }

        private void InitNormalSheet(SheetView sheetView)
        {
            var worksheet = sheetView.AsWorksheet();
            worksheet.Name = "No ColorRange";
            worksheet.Cells["A1"].Text = "Date";
            worksheet.Cells["B1"].Text = "Value";
            worksheet.Cells["D1"].Text = "Diagram";
            worksheet.RowCount = 367;

            worksheet.Cells["A2:A367"].CellType = new DateTimeCellType()
            {
                DateTimeFormat = DateTimeFormat.UserDefined,
                UserDefinedFormat = "yyyy-MM-dd"
            };

            worksheet.Columns["A"].ColumnWidth = 80;
            worksheet.Columns["B"].ColumnWidth = 60;
            worksheet.Columns["C"].ColumnWidth = 80;
            worksheet.Columns["D"].ColumnWidth = 600;

            worksheet.Cells["D3:M6"].Merge();

            DateTime date = new DateTime(2020, 1, 1);
            for (var row = 1; row < worksheet.RowCount; row++)
            {
                worksheet.Cells[$"A{row}"].Value = date.AddDays(row - 1);
                worksheet.Cells[$"B{row}"].Value = Math.Round(_rand.NextDouble() * 100);
            }

            worksheet.Cells["A1:C367"].HorizontalAlignment = GrapeCity.Spreadsheet.HorizontalAlignment.Center;
            sheetView.Cells["A1:D1"].BackColor = ColorTranslator.FromHtml("#999999");
            sheetView.Cells["A1:D1"].ForeColor = ColorTranslator.FromHtml("#FFFFFF");

            worksheet.Cells["D3"].Formula2 = $"YearSparkline(2020, A2:B{worksheet.RowCount}, \"#6d6d6d\", \"#c4c4c4\", \"#979797\", \"#f3f3f3\")";
        }
        #endregion
    }
}


//
//YearSparkline.Designer.cs
//



namespace Spread.Sparkline.Features
{
    partial class YearSparkline
    {
        /// <summary> 
        /// Required designer variable.
        /// </summary>
        private System.ComponentModel.IContainer components = null;

        /// <summary> 
        /// Clean up any resources being used.
        /// </summary>
        /// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param>
        protected override void Dispose(bool disposing)
        {
            if (disposing && (components != null))
            {
                components.Dispose();
            }
            base.Dispose(disposing);
        }

        #region Component Designer generated code

        /// <summary> 
        /// Required method for Designer support - do not modify 
        /// the contents of this method with the code editor.
        /// </summary>
        private void InitializeComponent()
        {
            System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(YearSparkline));
            this._fpSpread = new FarPoint.Win.Spread.FpSpread(FarPoint.Win.Spread.LegacyBehaviors.None, ((object)(resources.GetObject("pnlMain.Controls"))));
            this._fpSpread_Sheet1 = this._fpSpread.GetSheet(0);
            this._fpSpread_ColorRange = this._fpSpread.GetSheet(1);
            this.pnlMain.SuspendLayout();
            ((System.ComponentModel.ISupportInitialize)(this._fpSpread)).BeginInit();
            this.SuspendLayout();
            // 
            // pnlMain
            // 
            this.pnlMain.Controls.Add(this._fpSpread);
            // 
            // _fpSpread
            // 
            this._fpSpread.AccessibleDescription = "Book1, Sheet1, Row 0, Column 0";
            this._fpSpread.Dock = System.Windows.Forms.DockStyle.Fill;
            this._fpSpread.Font = new System.Drawing.Font("Calibri", 11F);
            this._fpSpread.Location = new System.Drawing.Point(0, 0);
            this._fpSpread.Name = "_fpSpread";
            this._fpSpread.Size = new System.Drawing.Size(477, 487);
            this._fpSpread.TabIndex = 0;
            this._fpSpread.ActiveSheetIndex = 0;
            // 
            // YearSparkline
            // 
            this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
            this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
            this.Name = "YearSparkline";
            this.pnlMain.ResumeLayout(false);
            ((System.ComponentModel.ISupportInitialize)(this._fpSpread)).EndInit();
            this.ResumeLayout(false);

        }

        #endregion

        private FarPoint.Win.Spread.FpSpread _fpSpread;
        private FarPoint.Win.Spread.SheetView fpSpread2_Sheet1;
        private FarPoint.Win.Spread.SheetView _fpSpread_Sheet1;
        private FarPoint.Win.Spread.SheetView _fpSpread_ColorRange;
    }
}
